SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045430 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045430 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417390,162117,267182,834781,302596,745204,393743,698431,537064,866863,844488,127306,581576,904133,486888,767568,675647,258773,577215,56776,444333,240562,793595,943408,287959,850493,55292,276043,926046,877021,199801,241645,823564,186723,642402,197468,942715,454893,347661,140058,705376,158999,563585,403613,919445,182660,463522,255354,880779,1048648,904012,439878,938550,565648,21007,396413,28739,1021319,218024,923645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001440s ]