SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028206 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028206 [ RunTime:0.002309s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411344,936237,635082,103755,855503,798682,371736,984415,66103,218245,687574,521743,100539,916198,741971,749032,633702,811637,540539,788965,221257,40691,984567,170210,939975,751188,637112,576626,870798,2279,466576,119640,93245,1022889,744533,877298,103424,294311,80514,1008798,138745,686384,502073,600045,870909,302403,208784,943088,67411,779324,843681,484205,433778,196940,586459,682080,81925,746871,80063,797599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000785s ]