SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560416 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560416 [ RunTime:0.002416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148173,642938,793183,450676,387316,491685,31846,784632,874248,1005266,328463,1025352,130520,174593,420731,639241,369198,807621,75094,29726,84606,914290,741270,370637,678536,5250,655670,989509,391195,183436,433606,596899,726276,370172,927892,1031987,879193,128915,336509,504970,684404,801655,233647,485674,746665,775529,279512,803729,271198,630619,959642,782308,322686,418633,1005889,531913,282001,993690,1015094,490023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001853s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000840s ]