SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205212 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205212 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541381,595932,1002589,918586,830957,1016185,986951,979022,923964,975836,999283,1024144,768200,787544,669241,788717,893943,713565,29149,978525,124165,1023926,650534,1016953,56774,785286,305663,59209,708582,77406,175814,329296,1010093,639696,628930,1043359,61223,826164,775034,943851,541345,945832,692247,1013915,468360,785687,254481,437201,915446,583413,54097,1004811,124751,769284,505546,515013,553921,388411,693379,18745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]