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` = 302742 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302742 [ RunTime:0.003554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030073,712542,510396,305791,1013796,789279,247838,42407,902204,38638,419518,273227,193195,88810,142745,854902,342380,979555,374093,786588,871127,577923,38206,438214,953073,986358,639606,562747,693988,750332,322902,785570,948802,341801,510153,184515,580807,110864,607449,873281,356504,699840,267283,790473,733697,574019,526324,807620,246590,736958,282387,79725,846888,256279,1011289,18613,376731,91180,1045150,534657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302742 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302742 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002250s ]