SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484521 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484521 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796260,120350,229465,414011,399319,227963,949338,420601,264724,44456,946071,758306,225922,435045,140561,435664,573042,652750,266356,810376,501127,1021840,805112,584524,914029,57686,810249,557911,151637,590591,440847,298431,856181,338047,595772,137146,543283,514159,750947,418446,989179,446140,828075,272895,755454,471382,125179,578052,583625,513179,819186,302735,712657,464983,1040562,741525,251640,561016,752892,422061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]