SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395399 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395399 [ RunTime:0.002321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468584,299605,570436,210615,320784,1032711,478043,592329,863052,882447,999385,664953,999340,652666,980977,275611,976395,787461,107867,269660,943965,1023577,288561,594354,352391,584517,647660,755135,690107,892066,207278,123212,752210,592822,143472,965139,837584,331413,794208,231010,459128,436432,989390,458807,502273,544077,793760,348953,82585,232283,814279,609282,801967,776648,522247,813495,769683,252347,488030,388418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]