SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584406 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584406 [ RunTime:0.002343s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510161,533209,850421,319054,256518,181554,326746,580911,771569,942081,831025,254730,148604,181303,178102,894217,253302,195453,829125,743353,76886,194974,769339,685978,817981,786417,832892,236620,316309,99312,240090,253947,164233,295253,36492,854122,19779,599583,260282,725429,485344,907951,727428,993860,657745,1036882,544075,499720,625792,370223,1017400,906349,598203,767757,524083,880077,737440,95539,464431,686212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001819s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]