SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017578 LIMIT 1 [ RunTime:0.000790s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017578 [ RunTime:0.014516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909867,446865,973001,656969,820378,279548,362749,705968,939288,701880,418848,682474,773796,633656,47560,254757,417904,859083,728971,412714,653507,765930,625011,418117,420569,1011670,190516,369028,992957,672161,993162,150482,699980,763312,696345,822387,762511,618962,581897,1042826,507965,224023,231758,381737,368045,931630,453140,552320,525574,730166,161243,241132,852188,781403,549998,779388,681199,300834,676183,691123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001180s ]