SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320414 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320414 [ RunTime:0.002405s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239255,73248,661637,867410,845717,533997,605551,469729,216982,148713,985379,393198,871218,870799,991529,950315,912936,858101,602632,289940,520790,1030098,685473,484257,408178,705065,469959,576518,1025956,592511,77532,910187,794403,441721,596945,154615,383402,913732,228130,83758,30660,472429,957731,761028,347345,234697,236135,878485,791596,1004021,713259,6178,930415,607909,678928,443713,215046,189586,875764,565140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002731s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000643s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001009s ]