SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282800 LIMIT 1 [ RunTime:0.000656s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282800 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945158,997540,787098,492064,418534,498427,1014942,343905,732204,256304,777143,374916,859920,254321,1021224,245616,919267,847035,587372,182997,400720,229518,140394,657472,980694,67989,82600,883611,1007301,491870,120282,637086,359568,882881,250518,1002855,30173,941287,119720,895874,309395,172831,498457,287342,825177,372371,747847,221019,644609,61792,377886,59605,2671,541471,421197,715497,1009421,256541,1035132,134082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]