SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429614 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429614 [ RunTime:0.001997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712129,386864,438700,28742,197839,639214,527668,746241,44566,537386,987753,853711,862781,258780,798703,7007,486741,955704,1046799,426987,61146,92893,73146,315704,676301,86410,812592,605381,805493,131545,362477,1000100,408800,812973,554234,1011163,873355,940511,475696,807883,435386,972567,492428,914566,869344,356942,564731,699316,319468,192849,126965,919495,961733,335204,883382,758122,181155,675063,437678,287943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]