SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029624 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029624 [ RunTime:0.002541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265034,49490,351833,14303,880475,779016,993676,899147,318489,904377,81827,142468,259623,794551,334157,154893,525303,470505,718197,281608,183328,572640,930084,187387,1006631,903248,252436,891692,451422,478904,136182,396470,399944,1031620,185751,500682,160437,844221,684526,379365,972423,1029340,713630,1011220,900621,492671,488479,906791,590445,574358,516538,122679,305525,765729,32259,923718,452210,929199,275486,1018672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029624 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001773s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029624 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]