SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576427 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576427 [ RunTime:0.004819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316241,987254,174661,718380,84523,483259,312696,899758,426258,744008,113536,695972,882202,112573,975303,198815,784017,171376,109735,471821,520356,348190,878640,507901,671750,285754,544829,245483,31840,258277,383050,564497,9985,957987,321809,298525,673157,179870,618620,840559,202844,878294,875924,141699,338363,351603,410794,667890,1004302,685113,393818,771155,744617,798027,354570,968562,429127,645636,749017,660105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]