SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 113388 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 113388 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (363743,982963,663590,1020034,540117,858418,443494,56639,581413,938300,690542,887148,11245,468642,926627,142460,897021,969800,122212,959489,35939,773695,554684,788429,807943,410249,170748,951238,465734,849778,827391,386411,216570,1035934,596610,107760,805571,464368,622250,21997,779919,169945,434665,407823,832250,238679,40920,87618,734242,150934,673033,173353,826554,976582,930636,485008,472306,732878,886769,411707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 113388 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 113388 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]