SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38203 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38203 [ RunTime:0.003764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10538,992885,423687,913401,106397,861552,710478,585891,843328,354982,600440,542110,526563,547301,896398,68662,104499,470720,737339,1037810,262442,464046,923803,956268,498204,613702,209147,884555,261246,681506,28324,749876,877216,661052,1021042,195721,580061,960551,447696,451892,813163,601428,252714,99131,979307,116,670939,775646,673549,710354,874262,1007252,952967,835716,563889,523094,37355,54979,965999,523554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]