SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473416 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473416 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518593,1001343,642337,682414,431316,793933,818985,327179,59819,913784,291937,386759,537486,46683,118618,894121,215172,451928,241922,781997,315810,792537,576257,249042,614013,277164,413309,458815,240336,30949,454619,808945,565314,518212,427405,507114,459847,673115,3822,596890,886811,77113,526739,167073,246408,453977,110982,879046,282772,920272,279669,26187,436840,584082,924928,1025566,731559,418031,67596,861885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]