SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 605023 LIMIT 1 [ RunTime:0.001189s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 605023 [ RunTime:0.002182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314135,898014,32499,792823,398847,241916,684391,105790,495899,500194,435168,861326,982933,573294,968882,303814,214160,657944,145059,428011,650433,486297,772522,584037,370724,9529,855255,110409,124418,690097,450572,699730,798329,120592,113139,848576,507824,314232,1028438,751495,766711,494347,1030187,945450,568297,231528,897258,144759,991673,261099,167534,530181,627084,133395,955350,769494,206266,271673,766,971692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 605023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 605023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]