SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526863 LIMIT 1 [ RunTime:0.000941s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526863 [ RunTime:0.001978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017548,102315,140589,713301,767235,508641,203107,999545,852753,98467,325436,611208,459430,29649,567968,317362,140631,890018,930955,300217,571804,54556,431255,602582,1002599,206668,256684,1044763,66162,79963,205783,534835,899524,618398,272449,1022510,121388,464748,496279,830322,249482,700191,201712,738802,647509,839090,346968,62511,550551,781471,28148,439233,633792,926948,1039793,233831,359913,107109,764291,270913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]