SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302211 LIMIT 1 [ RunTime:0.001117s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302211 [ RunTime:0.002231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412741,959023,12516,69864,883909,846313,930180,605709,253233,735943,167537,872934,50869,143232,914898,197249,822770,68347,901782,802530,721156,458604,377411,156597,484610,648324,831185,968950,21918,647737,1013270,524150,1037554,215485,430345,519215,857141,621402,852399,477217,90002,808715,467920,705366,165853,533558,982237,278939,597119,826500,720776,332271,741515,132437,197474,401481,390868,32496,469653,804175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]