SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 174583 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 174583 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381835,513812,855792,230434,442371,442401,982319,633358,856781,156024,299494,324074,140843,849577,242376,895206,86955,940610,181668,365667,895044,548475,772390,1034447,328746,635207,810983,800727,113961,559619,418529,398623,490512,65450,1004653,422526,1021352,361887,758469,611981,968622,58416,368587,175224,955662,354575,714707,901689,914143,348337,331664,847134,820436,533384,525085,734647,389181,16007,430136,471657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 174583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 174583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]