SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290940 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290940 [ RunTime:0.003435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (785200,453042,86243,106249,723158,291533,780504,381318,302395,710157,932619,503801,503731,751532,155889,651,1008306,655395,219645,446762,150922,769315,672808,714842,126258,979581,276146,557802,750495,336894,871767,482295,637901,886876,317683,1027197,276293,927698,3372,711996,730994,114949,637052,385506,183506,248187,775361,614258,634378,136426,463168,586718,800953,458820,225185,511193,561137,504354,721621,842295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]