SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488839 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488839 [ RunTime:0.002299s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514644,42102,191723,910598,1014527,261023,133258,530202,20096,887270,374539,12000,117506,938546,856713,52289,857691,75794,1031006,444314,311326,933425,11607,514659,123996,128522,351961,386235,1030572,19030,392526,421594,222416,525102,395585,926710,579336,942413,490137,148292,481332,370570,733260,551879,296829,784848,624190,1016791,110436,483909,394114,195378,464960,1005355,984531,941240,274420,873087,129739,46866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004046s ]