SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341047 LIMIT 1 [ RunTime:0.000828s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341047 [ RunTime:0.004142s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438595,600557,339428,634583,660550,910518,955774,404747,475064,815505,724004,58561,727674,300484,328488,625254,394214,679412,881522,591504,980231,592269,863101,189812,401329,466674,701890,74349,921572,6495,779828,526727,440304,654133,490191,382576,128671,450278,129390,132589,877767,784444,345676,862324,196424,942048,502446,470807,993932,87089,813816,162833,577457,1029162,461926,147869,973604,725995,910462,253720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]