SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000328 LIMIT 1 [ RunTime:0.000504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000328 [ RunTime:0.003022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837544,969208,93807,544602,623599,289122,379128,253441,221127,492557,364044,692630,681028,148720,496660,436098,38821,121380,485409,912163,198924,1039417,551318,407299,984555,32174,947520,200412,74615,102585,933247,283036,237817,639971,957069,944866,788026,616365,954730,970633,182599,422703,440876,367947,689347,119227,935194,777902,297165,348770,918272,291487,794413,242559,117846,997729,404543,607185,712068,69588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]