SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106648 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106648 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (272281,75611,444079,854612,151048,817155,102012,526634,553522,642502,12573,258451,507725,85229,7149,530879,663960,596409,538641,434096,1045425,462454,157686,398188,740733,871290,883904,919550,139823,349206,514524,103086,1023798,413348,985860,260927,229967,1017554,865084,136210,426301,46183,504717,92757,38901,938792,584936,495970,890041,310117,486736,918347,910849,370665,166740,128360,506675,385875,253297,182036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]