SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459272 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459272 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176986,315687,197840,12664,494239,453256,318402,624872,232423,338308,66060,145638,687761,403728,5245,918153,887398,158587,921406,891933,268011,543626,356546,433701,97609,754693,613444,140715,221469,547922,621458,171715,1001720,1027077,176661,234159,628150,185223,568592,689568,188832,27671,24448,347006,75234,613268,819135,255847,491860,907977,10428,1047739,859203,998208,953445,241977,677460,1001374,49066,516799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]