SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39573 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39573 [ RunTime:0.003497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4444,725125,922693,625035,431894,100848,426105,111445,430705,761166,886826,351264,244241,239511,265677,653681,256075,906318,151133,951661,787122,929455,788984,964368,806990,925793,888133,190430,1006705,744701,284395,44389,962151,834296,310438,944182,852164,685677,584040,348458,637808,342253,726829,21017,682645,969299,489210,912234,944995,808010,171270,189542,1013143,397599,896524,102325,331508,554997,669267,125018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001031s ]