SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414928 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414928 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (916036,1044730,297415,936840,488524,1044338,498907,329779,976725,60554,148992,130950,852997,930007,783555,890211,709976,612637,447677,1039459,430684,70657,128050,129307,872940,576435,385881,748240,254717,395564,16136,658764,83759,448213,823117,25482,75596,353751,611010,779555,64488,779634,368382,599701,335165,101330,11607,399253,197215,850286,757441,695918,360964,1034977,717425,254155,593479,913632,84977,341334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001889s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]