SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280131 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280131 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401726,77326,130536,685863,190072,934983,926510,783452,834797,158124,907690,110568,569964,743171,74419,1026193,579185,349378,290451,412456,143964,79439,364482,393429,887662,752529,611244,137966,1024665,262825,980991,483024,790577,464112,373478,597882,352021,541430,590350,253241,789787,217020,737750,740636,710081,957382,884243,839902,961686,237149,766827,830980,286426,168338,321521,560429,694504,931956,791586,444617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001300s ]