SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023201 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023201 [ RunTime:0.003858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614527,287067,969750,992916,766871,929201,465843,535514,125052,148197,177029,874105,860631,570664,301666,826254,1029922,310567,310894,978306,528476,1039371,956222,1000234,500174,520071,279721,994482,332782,150900,552216,455932,97420,917224,14263,138458,723665,452081,1047785,13023,573864,361340,733198,675983,86886,866386,610009,942381,612518,180175,629685,827393,695541,207216,970106,92,498976,364259,954171,133455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]