SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291455 LIMIT 1 [ RunTime:0.000505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291455 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176724,1045959,658201,918503,406748,501724,830990,346991,889685,585150,547785,658100,34430,931458,144703,901504,920614,217681,974623,441395,999004,836901,110431,480979,572490,497891,1008956,296327,676020,40355,613381,1047449,812975,271030,817310,611350,581743,7474,255514,729979,251836,193632,439736,19540,111076,410963,100808,526480,891772,626802,918372,955481,772310,670369,840872,874094,409879,731687,783360,464580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000741s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]