SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 250191 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 250191 [ RunTime:0.002155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364039,513686,299563,602092,383438,68004,649505,821880,294981,694449,518162,1042794,106623,965347,974711,648527,1017134,780617,69646,744558,296791,161826,115680,622705,401122,89837,41970,550027,556633,658741,351588,1017608,125396,207016,543583,100444,130885,88174,68167,1893,136456,861549,719476,596383,527649,124816,912967,272884,110731,501387,575581,398648,1031615,1013272,773053,501287,252424,918654,641938,1040070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 250191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 250191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]