SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58083 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58083 [ RunTime:0.006086s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381858,119225,162596,220019,328393,404643,375182,95652,664693,185467,502947,381070,36096,508501,629094,718885,733529,752722,543468,278665,306554,30613,133314,923156,267772,588401,134521,735488,910596,1030996,239411,737217,224055,739237,979828,340978,76693,575418,307790,732169,977553,471492,789118,507647,128163,1027955,500925,284784,845134,568409,237222,690924,513234,351427,273858,966233,594855,172789,71671,566054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000729s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]