SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435693 LIMIT 1 [ RunTime:0.003011s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435693 [ RunTime:0.001993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71444,291895,30319,634616,879878,254758,1021132,1025442,327918,618244,893271,740966,718258,564457,536421,1041276,141030,891494,615664,519573,1015387,61531,304409,965104,836638,480457,54358,1011813,664522,569305,39442,165406,32217,852824,601805,407292,454113,730893,931539,877746,375190,382508,458052,842090,1006264,727220,473468,233726,315620,251847,521722,758532,465062,346427,835781,463123,893860,913519,508689,178941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]