SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418210 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418210 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603768,1045078,225816,438000,555448,462097,505323,421247,243548,532941,407579,698651,901972,697970,656302,859896,599423,920116,868832,921419,324070,952645,389031,1036109,81254,845226,390661,785832,487154,312295,240425,1041218,813317,690888,1017145,440668,54254,343433,379845,858140,258371,743991,114314,73382,940694,928987,1016121,1019243,434920,693132,1003575,282325,536452,957487,960226,294010,164138,575792,463846,680967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]