SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 171940 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 171940 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639820,299484,193751,129146,3907,96074,58699,219132,833935,834760,918895,862372,375132,675508,976802,339911,110141,902104,399905,8551,293434,337066,404038,851223,344121,960117,623796,837320,286769,242131,75163,657463,973875,221198,661569,346565,752345,464219,1029749,850605,435754,248760,686445,760004,857586,646964,487127,543389,1014223,959671,436326,730574,129393,1026617,697192,973887,896001,401163,10238,12745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 171940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 171940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]