SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406417 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406417 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016916,400143,455639,778235,821612,665678,660641,257965,672003,545460,452030,106793,914748,923003,603364,470883,87524,726681,205113,995418,76321,506783,459564,76827,604152,265646,1037742,427091,95293,843228,445892,582565,369188,53019,433064,188456,394823,84466,884507,806769,832884,246539,433237,996522,336170,1026518,426325,302841,228588,767557,680560,763280,225089,537679,26585,354225,682257,327487,319423,662276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000854s ]