SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305107 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305107 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583580,735260,1002051,721546,796909,621823,455157,1045649,951000,719428,503700,136033,867675,958657,983591,850917,24973,9889,873248,110196,881361,798040,380793,10069,1010096,392973,911297,928456,554602,197597,931129,476269,146737,664105,1014990,1039447,3451,657347,838445,450725,685768,362919,96753,423685,574194,40378,152797,948053,535512,540549,581516,505386,946074,194137,335517,524256,431810,413444,79248,834099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]