SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336761 LIMIT 1 [ RunTime:0.000563s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336761 [ RunTime:0.003295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714364,565970,298869,884838,694731,407203,1014526,110443,913122,868301,167150,108438,748487,285576,447760,527949,666875,774382,893897,750333,524612,459013,283132,371092,590786,46474,14656,404220,482728,570117,828406,800104,697898,177983,33594,1011001,51743,308073,549282,758320,641977,114872,674093,151835,1030116,592315,128160,70607,45408,784032,987685,838011,869836,1028062,686751,742767,258458,38375,145869,451127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336761 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336761 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]