SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 139141 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 139141 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117869,943280,238482,1008107,1033218,1037527,395590,905261,16989,231821,478458,251510,679928,1024891,491733,538378,925794,169584,705767,844399,601577,528978,894631,937895,992882,259786,1034083,93127,148945,992482,817760,120690,409172,13813,145169,963860,528823,642164,921522,291264,186016,60445,962586,658155,382132,86261,246201,548487,960156,152937,1042595,219023,218238,153319,496632,716522,807752,211475,997132,1013187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 139141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 139141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]