SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190204 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190204 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533464,1033229,413201,729173,477313,332649,324976,808602,782115,670529,455725,122438,430305,592,662569,581043,693491,581264,514269,473554,400342,1017328,846311,828656,668601,930260,695868,801736,552401,753115,605117,654225,856261,522962,932717,131763,984799,1015007,639148,948979,939401,509780,804945,742252,773041,544747,148007,537722,759195,757353,247542,571142,875978,652356,265708,786473,773018,906528,479057,674735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]