SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508181 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508181 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582930,758626,442803,714949,66724,729273,672354,1018200,838121,778575,664288,1001267,712242,672911,679431,1034487,719017,159487,699301,1003949,686623,186853,895647,294393,226721,802444,929418,934258,242212,59458,231570,355890,833268,1004331,1022136,452821,88418,439909,785203,237958,714318,661746,608916,464529,568144,425625,684985,218120,254409,119204,367727,715793,616403,440627,371,939057,568942,527828,185216,779781) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000763s ]