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` = 1023321 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023321 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964418,208651,602860,40241,682311,972626,640014,785120,437921,551562,646688,19149,388545,440349,567535,550490,46799,753779,948973,966484,415385,487911,547661,491135,776122,523489,479766,313266,378032,436504,74056,250322,73480,113332,850604,60581,824321,100576,966201,747690,100698,1010866,829788,337302,1031680,270402,381726,415536,691260,707427,455577,594138,335453,59396,528833,811430,308134,50573,399209,703212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]