SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490240 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490240 [ RunTime:0.002581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878908,852428,580509,33460,800002,880589,487130,634403,33638,100966,28064,442130,399147,986135,458797,980970,788080,265031,679249,948294,2327,138795,856967,338171,217540,920699,332052,572860,11443,829802,14866,966500,451280,1044627,668537,189425,652995,880192,308472,963363,999916,156843,696644,194921,1045256,719719,268516,905458,550877,779596,383572,1003088,1017139,983639,422387,200621,514627,983968,354946,11249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]