SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518001 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518001 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (906345,710351,573643,30209,994779,627200,771536,798190,383893,736925,861544,451331,866478,774320,347098,720318,748596,240052,150039,380148,527043,768217,599927,24682,949551,380854,293317,109174,899481,775734,820203,875354,488054,572620,750188,560415,675424,958499,942820,624277,193051,149749,687598,112868,243356,102507,41247,502454,255376,1021949,321592,729892,547010,667539,218927,61874,32525,603796,897086,1033672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]