SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346640 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346640 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161831,239305,521841,531868,898767,140033,1034288,347313,561685,950966,107687,841145,1004824,722131,553604,35434,440845,291441,153926,227481,346521,1025003,834270,81925,719455,414797,1031109,683585,690619,198739,406029,828833,330197,293245,434968,465265,451777,47983,93306,216658,736602,353252,791885,572130,986957,1006027,332988,229243,166127,949786,786487,1018075,445041,127443,731257,523113,798719,330629,689613,17828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]