SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460818 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460818 [ RunTime:0.001463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648984,924375,948709,491967,229378,223277,89903,753729,104222,85908,100092,740674,1028549,365910,886347,673625,304035,489952,297502,673051,100545,573473,599097,441518,597396,531409,419668,739263,725865,780689,268334,276849,371444,679554,447836,649629,370183,376867,16350,882728,78885,993710,320227,258753,516982,397,452428,767441,698781,101506,72550,460536,181442,374148,1044651,749003,869246,503466,107275,336171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]