SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469691 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469691 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665161,368789,775279,932041,673631,735204,427823,261403,28023,153267,663636,853602,136236,56912,617892,1040843,186041,508827,987016,583280,1036999,483293,740136,314491,267578,493170,703176,272508,985098,379788,298341,506101,701992,128638,595489,975793,292013,713196,517547,625400,986567,240206,807716,13034,251197,523249,494639,55233,290786,931603,874066,517772,592373,52617,245475,6540,944699,46691,813650,1044237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000880s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002503s ]