SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261575 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261575 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304429,572575,912715,1029298,952753,248805,204525,861682,695280,172427,668990,399526,969041,1016955,387267,935681,438391,492591,903678,66101,260951,643052,995853,800546,474565,490572,767378,747763,361189,266213,192733,619302,180118,16404,862786,309689,411096,63764,34512,932823,115136,986271,518353,885288,695515,739933,846235,499917,531641,195079,853188,385826,67531,152479,770350,573650,719155,21903,628695,72374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]