SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203438 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203438 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464838,174315,803304,847665,3225,835434,199665,1038175,489112,490465,502361,86203,539209,989317,417459,945041,220148,115845,119387,725802,767069,650317,291193,559116,310454,123053,738054,900335,182871,213830,1008587,1020821,790951,18104,989921,43064,708733,612068,461778,838398,1007728,239879,726405,879161,726572,285692,877390,21826,797547,552342,484212,544203,307988,26405,204307,610137,677317,659797,244012,732139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]