SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001735s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584153 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584153 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798307,686940,1021235,21700,20638,710607,545698,181215,956377,898630,547610,17471,396241,459740,860631,732968,808239,100121,55936,734183,1034973,938985,819996,27066,853217,887893,1001398,177891,103944,117301,255274,188923,273154,719072,811716,1030725,500065,263131,613218,398129,756630,1007450,432478,958248,470977,77796,83426,573156,862420,149723,879934,360774,874823,671897,360445,66850,911819,558759,392394,806585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]