SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10124 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10124 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763981,670133,145501,431953,1039080,804185,385116,829260,885584,808327,929680,641030,676092,188724,199628,1041448,196508,763387,815736,213899,719421,121235,976867,974834,636363,900427,610339,452334,70716,572394,573971,939055,387059,506062,209732,397131,580156,725215,840073,524783,985654,433405,5895,728360,787221,348063,396299,1030597,432799,615143,794357,810395,152707,334242,84457,335094,813025,1016342,347541,776361) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10124 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10124 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]