SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5089 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5089 [ RunTime:0.003358s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613045,951852,511646,118895,845563,570421,264580,678948,704718,339914,421366,795217,910800,220988,237573,757248,543440,733393,1007434,509522,661181,183717,975635,12994,373131,934586,728958,407804,930791,14714,236763,81567,292343,608817,907727,260838,62917,86882,720708,963522,712619,672250,219041,955007,78537,545917,781828,374596,338330,611498,222386,100141,1019805,35328,271977,191215,794929,977554,836388,437910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]