SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42898 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42898 [ RunTime:0.002387s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26800,582744,1025038,417488,987296,771835,269372,247911,244287,74700,146854,89046,165674,715286,1047347,561834,651665,1047663,546759,332638,31473,934320,202426,866985,368668,393978,985964,509279,948542,765420,215513,101693,23698,501083,559902,194304,1046324,231957,1034779,230823,589220,425365,554975,629263,403049,544611,337489,1020723,770396,1039496,572740,211460,164052,166864,678095,919654,129390,4029,827603,322530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]