SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538026 LIMIT 1 [ RunTime:0.005946s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538026 [ RunTime:0.002862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226212,239765,102126,112609,995300,240391,307964,503811,593799,774041,106294,352570,306218,18890,263527,595442,304328,622306,465600,643489,188491,615307,240241,681653,1022560,10602,853571,901708,245709,1031017,343289,911567,205594,71216,599836,1006815,672481,400599,1000589,683808,150723,170033,694992,353632,569683,128178,204362,673688,523140,690845,489062,214937,428531,78117,713276,1009689,841115,308659,497814,79702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004689s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]