SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40914 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40914 [ RunTime:0.004723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162854,794898,827471,64824,123983,737740,246072,377971,416668,504281,28743,378058,9637,823552,747335,333243,487636,843857,382215,909436,711955,398474,818116,921495,901578,477885,81605,247976,744233,423908,670842,1013989,873924,119436,377828,425466,79167,656109,571022,495807,502435,807682,124537,515905,735938,23878,872088,427451,538738,771734,439216,563042,716386,602038,246746,881128,1032803,885935,201031,140406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]