SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451209 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451209 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516188,380755,952474,668498,311292,268922,410073,124732,287301,390192,799629,868623,175927,408946,345553,726281,42664,664553,445604,726731,50503,269702,806055,468014,147670,706638,417468,832452,613002,920745,784725,1009667,453284,298626,602099,607397,434791,809636,682653,352112,103849,655465,485272,704307,986935,763117,693340,176478,350689,1017664,680767,92977,404067,498460,597190,125571,396014,570790,377785,190580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]