SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005485s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981307 LIMIT 1 [ RunTime:0.003873s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981307 [ RunTime:0.003650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622092,560912,92913,182856,209515,112422,791113,372298,400157,749524,821465,1008703,183836,14917,584835,580059,844240,984295,548471,578145,553698,953727,646454,776490,822442,448445,617754,244329,855739,236974,374590,70773,238556,943939,669709,910357,115199,68715,561961,940255,281710,811926,288555,488551,1020212,1020855,885214,475732,883181,520053,478524,529653,100110,572454,523797,39879,173789,871688,997791,86887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001463s ]