SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 672607 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 672607 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498036,521276,665184,979975,988653,965949,142312,579763,885411,720176,549146,394550,681912,867524,534167,76042,439190,171996,393416,764292,825414,827255,63541,160517,925940,942644,1014854,571008,84302,910788,1048324,561322,189258,441473,922983,304443,243532,486775,622432,1015716,322233,486780,846849,617065,758656,438160,859666,328632,1041686,516402,159479,39965,936321,829859,875038,836258,220529,197371,239629,281889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 672607 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 672607 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000381s ]