SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521171 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521171 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872815,693615,577368,532018,507111,1008559,457290,1034374,627494,1028263,1028027,907801,368222,213240,890857,1032442,787430,970466,266870,491310,739613,523000,196052,340058,823535,110249,369348,920679,463523,604442,825660,582483,15242,37319,805662,492842,496142,56599,20634,782816,945380,340601,892216,977588,563875,417241,225050,783289,92305,557488,473840,858675,62017,960615,281438,20201,967828,140069,444258,40912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]