SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102951 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102951 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575063,157906,121256,541180,515137,968238,345690,1025279,470099,854873,304613,419570,193205,782240,686222,596029,660513,425888,913529,815210,117827,93679,687287,308178,512122,474551,543124,274569,737559,756715,691923,269564,170284,591785,23534,596873,707646,940267,268638,1008713,938634,354222,632867,926614,212611,655617,801443,593592,392966,660266,996946,765302,865160,567912,31044,223455,316442,763389,45841,432842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]