SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52801 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52801 [ RunTime:0.002184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043525,795088,908182,189290,812687,626566,951904,494355,340,584571,280871,993927,760295,729443,704601,183433,14932,1006294,900870,397296,1037426,970350,107044,677876,290456,87698,511204,459234,852054,216350,278430,636894,68633,143886,31361,189126,240212,562787,24921,569649,97870,716099,796800,803040,215876,706544,79916,736947,271072,176294,601905,242912,810524,1043897,497860,92633,747515,518774,382676,43001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]