SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016156 LIMIT 1 [ RunTime:0.002843s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016156 [ RunTime:0.004657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53423,99824,178549,386922,193535,735477,143588,742762,813605,661828,942048,266269,704951,640298,987938,454439,851226,848617,612940,800563,628248,690919,458027,761038,486383,5419,966410,204779,428767,18670,781052,474652,273497,571115,872549,355845,988754,410955,953556,138069,637506,225925,532052,14393,12493,832281,218138,884841,784320,108463,616267,184865,77566,964632,404294,168256,107676,786781,322322,824747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016156 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016156 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001145s ]