SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003601s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42150 LIMIT 1 [ RunTime:0.000687s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42150 [ RunTime:0.003346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387483,959399,505592,7566,418409,826509,802311,808104,286684,1029985,167652,556459,916168,763960,560347,717481,1044965,175210,643588,414974,378921,829169,715642,756115,805799,123555,423295,273560,603936,521801,379062,429629,680155,118815,422114,117003,902476,780116,397508,381862,867577,474629,225748,647322,800663,1021135,585105,642576,142071,842697,761695,470259,95490,20823,548942,870271,432838,689620,56238,250056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]