SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328891 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328891 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017677,76296,662445,534000,783745,416322,756764,450175,543340,908510,645500,254399,849422,62825,590911,867596,665036,250465,691545,856686,793389,690721,418065,240191,213530,691620,940983,254531,601633,457132,100363,362606,498422,100232,1007198,332021,462132,901380,990521,222897,217883,839670,824989,516255,492759,904242,275507,452104,209717,772012,547725,933034,154434,885765,217991,761607,277200,170221,109328,123384) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]