SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109907 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109907 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543599,611107,371541,86761,444192,247866,172642,806113,585687,528567,262037,1048852,26660,97009,556786,3273,970666,110743,674517,754195,1011879,390317,485194,847441,712048,104470,420510,949877,1043993,914402,997124,436692,968688,444217,554549,927721,528201,379382,925070,550451,1034080,515093,1035018,93294,326758,11423,250011,230778,608732,98392,732496,666355,855833,689885,616067,23747,119589,317336,89800,765151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003634s ]