SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 716181 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 716181 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51749,311143,1019742,230102,323361,687128,25895,996007,44130,949102,86197,290618,163483,248215,47375,519802,856867,980684,545403,12181,50189,40918,932478,732069,641170,975149,856860,772993,840443,24301,769696,525274,199150,602597,87404,932184,540324,97402,541116,631052,990995,20539,44370,734170,986957,289217,155151,440125,793992,359552,485357,546561,404957,70040,176186,648408,970442,955528,531075,495104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 716181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 716181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]