SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328213 LIMIT 1 [ RunTime:0.000956s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328213 [ RunTime:0.003084s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820990,349145,809606,564854,68360,898140,125287,350310,932152,1018550,440332,264657,30359,555416,148170,1041053,71486,141947,36343,920792,165400,837080,809157,226594,1007158,950660,740586,697734,115196,1047985,837023,12001,216110,692032,289952,418529,757381,86443,168559,1037830,268370,997384,746754,241916,854820,122936,1018161,699711,353222,556549,342919,757610,500616,126060,943631,774393,242632,894200,902048,605133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001111s ]