SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44530 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44530 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665687,844977,577130,483856,1010693,8509,546061,758541,540946,510051,604082,376615,356197,810925,225219,456251,582757,209079,817140,534770,225184,963710,419745,125587,113238,868178,386677,717493,427403,794316,997750,867424,484337,216489,364594,953739,480528,88043,942311,716944,126963,585659,956344,633009,155302,560527,364025,494891,147410,754439,919667,254459,637680,973724,125829,176742,282364,177288,154160,291243) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44530 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44530 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]