SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404833 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404833 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316699,588443,395974,232474,543761,841090,940808,707019,549114,132820,832356,868409,668157,425590,22216,127721,924411,885615,986330,502100,58532,937333,808037,871523,405057,664066,694563,162323,1002665,904310,238238,490119,96931,731223,170753,429891,871171,685442,1021161,482452,155000,595650,1018022,878944,374631,120782,1026089,675942,139357,94238,771661,151398,161099,646621,590604,924352,171200,204431,588693,860464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]