SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 831516 LIMIT 1 [ RunTime:0.000575s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 831516 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414039,877336,284559,313413,107330,390389,605965,131498,274782,456751,323053,369790,76553,375079,848713,884673,769538,10236,396448,122171,799277,114707,924038,520067,265221,1003438,1007152,472585,153486,278895,858330,888310,496095,790304,768341,876109,844336,775520,772119,457658,451843,213490,819871,65754,995726,701078,1048216,264133,235503,178729,238039,177501,633332,721530,253182,783597,949837,974347,309045,1001653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 831516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 831516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]